
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE proc [dbo].[IsLogin]
(
 @username nvarchar (50),
 @password nvarchar (50)
 )
AS 
SELECT UserName,HotelID  from Admin_Users 
WHERE UserName = @username and 
[Password] = @password and [Status] = 1 
GO
